* Data creation;

data EmpsDUP;
   input First $ Gender $ EmpID;
   cards;
Matt	M	121160
Julie	F	121161
Brett	M	121162
Julie	F	121161
Chris	F	121161
Julie   F   	121163
;
run;

* Eliminating duplicates of the BY statement;

proc sort data=EmpsDUP 
          out=EmpsDUP1 nodupkey equals;
  by EmpID;
run;

proc print data=EmpsDUP1;
run;

* Eliminating duplicates based on observation
This will include Chris but with his incorrect employee ID number;

proc sort data=EmpsDUP 
          out=EmpsDUP2 noduprecs;
  by EmpID;
run;

proc print data=EmpsDUP2;
run;